EDA automático

Dataset statistics

Number of variables	13
Number of observations	446.014
Missing cells	1.163.037
Missing cells (%)	20.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	38.3 MiB
Average record size in memory	90.0 B

Variable types

DateTime	1
Numeric	9
Categorical	2
Text	1

Alerts

`Estación` has a high cardinality: 91 distinct values	High cardinality
`CO (mg/m3)` has 344856 (77.3%) missing values	Missing
`NO (ug/m3)` has 30984 (6.9%) missing values	Missing
`NO2 (ug/m3)` has 32517 (7.3%) missing values	Missing
`O3 (ug/m3)` has 170600 (38.2%) missing values	Missing
`PM10 (ug/m3)` has 101435 (22.7%) missing values	Missing
`PM25 (ug/m3)` has 392230 (87.9%) missing values	Missing
`SO2 (ug/m3)` has 89737 (20.1%) missing values	Missing

Reproduction

Analysis started	2024-11-21 08:58:55.741156
Analysis finished	2024-11-21 08:59:00.931066
Duration	5.19 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

Fecha
Date

Distinct	8766
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

Minimum	1997-01-01 00:00:00
Maximum	2020-12-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

CO (mg/m3)
Real number (ℝ)

MISSING

Distinct	100
Distinct (%)	0.1%
Missing	344856
Missing (%)	77.3%
Infinite	0
Infinite (%)	0.0%
Mean	0.85462445

Minimum	0
Maximum	25.1
Zeros	89
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0.1
Q1	0.3
median	0.7
Q3	1.1
95-th percentile	2.3
Maximum	25.1
Range	25.1
Interquartile range (IQR)	0.8

Descriptive statistics

Standard deviation	0.78522551
Coefficient of variation (CV)	0.91879598
Kurtosis	23.281004
Mean	0.85462445
Median Absolute Deviation (MAD)	0.4
Skewness	3.0068936
Sum	86452.1
Variance	0.6165791
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1	10122	2.3%
0.2	8515	1.9%
0.4	8264	1.9%
0.3	7820	1.8%
0.5	7614	1.7%
0.6	7364	1.7%
0.7	6907	1.5%
0.8	6206	1.4%
0.9	5278	1.2%
1	4599	1.0%
Other values (90)	28469	6.4%
(Missing)	344856	77.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	89	< 0.1%
0.1	10122	2.3%
0.2	8515	1.9%
0.3	7820	1.8%
0.4	8264	1.9%
0.5	7614	1.7%
0.6	7364	1.7%
0.7	6907	1.5%
0.8	6206	1.4%
0.9	5278	1.2%

Value	Count	Frequency (%)
25.1	1	< 0.1%
15.5	1	< 0.1%
13.1	1	< 0.1%
12.1	1	< 0.1%
11.1	1	< 0.1%
9.9	1	< 0.1%
9.6	1	< 0.1%
9.5	2	< 0.1%
9.4	2	< 0.1%
9	1	< 0.1%

NO (ug/m3)
Real number (ℝ)

MISSING

Distinct	360
Distinct (%)	0.1%
Missing	30984
Missing (%)	6.9%
Infinite	0
Infinite (%)	0.0%
Mean	13.225808

Minimum	-441
Maximum	634
Zeros	3472
Zeros (%)	0.8%
Negative	3
Negative (%)	< 0.1%
Memory size	3.4 MiB

Quantile statistics

Minimum	-441
5-th percentile	1
Q1	2
median	5
Q3	15
95-th percentile	52
Maximum	634
Range	1075
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	21.970729
Coefficient of variation (CV)	1.6612013
Kurtosis	39.722907
Mean	13.225808
Median Absolute Deviation (MAD)	4
Skewness	4.6985519
Sum	5489107
Variance	482.71295
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	67032	15.0%
2	54774	12.3%
3	35928	8.1%
4	26810	6.0%
5	21890	4.9%
6	17691	4.0%
7	15166	3.4%
8	13163	3.0%
9	11770	2.6%
10	9851	2.2%
Other values (350)	140955	31.6%
(Missing)	30984	6.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-441	1	< 0.1%
-374	1	< 0.1%
-367	1	< 0.1%
0	3472	0.8%
1	67032	15.0%
2	54774	12.3%
3	35928	8.1%
4	26810	6.0%
5	21890	4.9%
6	17691	4.0%

Value	Count	Frequency (%)
634	1	< 0.1%
610	1	< 0.1%
511	1	< 0.1%
470	1	< 0.1%
464	1	< 0.1%
434	1	< 0.1%
419	1	< 0.1%
418	1	< 0.1%
408	1	< 0.1%
406	1	< 0.1%

NO2 (ug/m3)
Real number (ℝ)

MISSING

Distinct	207
Distinct (%)	0.1%
Missing	32517
Missing (%)	7.3%
Infinite	0
Infinite (%)	0.0%
Mean	21.409154

Minimum	0
Maximum	249
Zeros	138
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	8
median	16
Q3	29
95-th percentile	59
Maximum	249
Range	249
Interquartile range (IQR)	21

Descriptive statistics

Standard deviation	19.108434
Coefficient of variation (CV)	0.89253569
Kurtosis	5.8664319
Mean	21.409154
Median Absolute Deviation (MAD)	10
Skewness	1.9289765
Sum	8852621
Variance	365.13225
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	15082	3.4%
2	14632	3.3%
5	14586	3.3%
6	14563	3.3%
3	14422	3.2%
7	14359	3.2%
8	13873	3.1%
9	13492	3.0%
10	13176	3.0%
11	12917	2.9%
Other values (197)	272395	61.1%
(Missing)	32517	7.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	138	< 0.1%
1	11829	2.7%
2	14632	3.3%
3	14422	3.2%
4	15082	3.4%
5	14586	3.3%
6	14563	3.3%
7	14359	3.2%
8	13873	3.1%
9	13492	3.0%

Value	Count	Frequency (%)
249	1	< 0.1%
238	1	< 0.1%
228	1	< 0.1%
222	1	< 0.1%
221	1	< 0.1%
214	1	< 0.1%
211	1	< 0.1%
210	1	< 0.1%
207	1	< 0.1%
204	1	< 0.1%

O3 (ug/m3)
Real number (ℝ)

MISSING

Distinct	185
Distinct (%)	0.1%
Missing	170600
Missing (%)	38.2%
Infinite	0
Infinite (%)	0.0%
Mean	52.619754

Minimum	0
Maximum	999
Zeros	7
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	37
median	54
Q3	68
95-th percentile	87
Maximum	999
Range	999
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	23.221958
Coefficient of variation (CV)	0.44131635
Kurtosis	128.24065
Mean	52.619754
Median Absolute Deviation (MAD)	15
Skewness	3.7983809
Sum	14492217
Variance	539.25934
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60	5111	1.1%
61	5094	1.1%
57	5038	1.1%
59	4994	1.1%
56	4922	1.1%
62	4906	1.1%
58	4889	1.1%
63	4873	1.1%
54	4844	1.1%
55	4813	1.1%
Other values (175)	225930	50.7%
(Missing)	170600	38.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	< 0.1%
1	223	< 0.1%
2	290	0.1%
3	485	0.1%
4	638	0.1%
5	779	0.2%
6	823	0.2%
7	931	0.2%
8	1014	0.2%
9	1136	0.3%

Value	Count	Frequency (%)
999	1	< 0.1%
991	1	< 0.1%
976	1	< 0.1%
965	1	< 0.1%
934	1	< 0.1%
903	1	< 0.1%
899	1	< 0.1%
892	1	< 0.1%
881	1	< 0.1%
871	1	< 0.1%

PM10 (ug/m3)
Real number (ℝ)

MISSING

Distinct	237
Distinct (%)	0.1%
Missing	101435
Missing (%)	22.7%
Infinite	0
Infinite (%)	0.0%
Mean	22.694662

Minimum	0
Maximum	557
Zeros	107
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	11
median	18
Q3	29
95-th percentile	57
Maximum	557
Range	557
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	17.919319
Coefficient of variation (CV)	0.789583
Kurtosis	13.698174
Mean	22.694662
Median Absolute Deviation (MAD)	8
Skewness	2.4617604
Sum	7820104
Variance	321.10201
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	14349	3.2%
10	14264	3.2%
8	13778	3.1%
11	13618	3.1%
12	13314	3.0%
13	12752	2.9%
14	12569	2.8%
7	12265	2.7%
15	12087	2.7%
16	11473	2.6%
Other values (227)	214110	48.0%
(Missing)	101435	22.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	107	< 0.1%
1	1284	0.3%
2	2665	0.6%
3	3471	0.8%
4	5075	1.1%
5	7281	1.6%
6	9813	2.2%
7	12265	2.7%
8	13778	3.1%
9	14349	3.2%

Value	Count	Frequency (%)
557	1	< 0.1%
343	1	< 0.1%
339	1	< 0.1%
321	2	< 0.1%
314	1	< 0.1%
292	1	< 0.1%
290	1	< 0.1%
289	1	< 0.1%
284	1	< 0.1%
252	1	< 0.1%

PM25 (ug/m3)
Real number (ℝ)

MISSING

Distinct	177
Distinct (%)	0.3%
Missing	392230
Missing (%)	87.9%
Infinite	0
Infinite (%)	0.0%
Mean	13.677172

Minimum	0
Maximum	223
Zeros	9
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	5
median	9
Q3	15
95-th percentile	46
Maximum	223
Range	223
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	15.895495
Coefficient of variation (CV)	1.1621916
Kurtosis	18.879228
Mean	13.677172
Median Absolute Deviation (MAD)	5
Skewness	3.5589683
Sum	735613
Variance	252.66675
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5	3727	0.8%
6	3723	0.8%
4	3662	0.8%
7	3512	0.8%
3	3409	0.8%
8	3376	0.8%
9	3183	0.7%
2	2924	0.7%
10	2722	0.6%
11	2546	0.6%
Other values (167)	21000	4.7%
(Missing)	392230	87.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	< 0.1%
1	1178	0.3%
2	2924	0.7%
3	3409	0.8%
4	3662	0.8%
5	3727	0.8%
6	3723	0.8%
7	3512	0.8%
8	3376	0.8%
9	3183	0.7%

Value	Count	Frequency (%)
223	1	< 0.1%
218	1	< 0.1%
216	1	< 0.1%
205	1	< 0.1%
196	2	< 0.1%
193	1	< 0.1%
188	1	< 0.1%
186	1	< 0.1%
183	1	< 0.1%
179	1	< 0.1%

SO2 (ug/m3)
Real number (ℝ)

MISSING

Distinct	251
Distinct (%)	0.1%
Missing	89737
Missing (%)	20.1%
Infinite	0
Infinite (%)	0.0%
Mean	9.0928014

Minimum	-791
Maximum	364
Zeros	1116
Zeros (%)	0.3%
Negative	41
Negative (%)	< 0.1%
Memory size	3.4 MiB

Quantile statistics

Minimum	-791
5-th percentile	1
Q1	2
median	5
Q3	11
95-th percentile	31
Maximum	364
Range	1155
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	13.79075
Coefficient of variation (CV)	1.5166668
Kurtosis	338.90028
Mean	9.0928014
Median Absolute Deviation (MAD)	3
Skewness	-2.5880381
Sum	3239556
Variance	190.18477
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	46443	10.4%
1	44183	9.9%
3	38786	8.7%
4	32839	7.4%
5	26597	6.0%
6	21112	4.7%
7	17852	4.0%
8	14822	3.3%
9	12354	2.8%
10	10323	2.3%
Other values (241)	90966	20.4%
(Missing)	89737	20.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-791	1	< 0.1%
-783	1	< 0.1%
-780	1	< 0.1%
-773	3	< 0.1%
-767	1	< 0.1%
-763	2	< 0.1%
-399	1	< 0.1%
-393	2	< 0.1%
-388	1	< 0.1%
-387	1	< 0.1%

Value	Count	Frequency (%)
364	1	< 0.1%
360	1	< 0.1%
358	1	< 0.1%
344	1	< 0.1%
326	1	< 0.1%
320	1	< 0.1%
270	1	< 0.1%
261	1	< 0.1%
250	1	< 0.1%
248	1	< 0.1%

Provincia
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	436.1 KiB

León	176821
Valladolid	80460
Palencia	61857
Burgos	57906
Salamanca	31204
Other values (5)	37766

Length

Max length	10
Median length	9
Mean length	6.3943778
Min length	4

Characters and Unicode

Total characters	2.851.982
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Burgos
2nd row	León
3rd row	León
4th row	León
5th row	León

Common Values

Value	Count	Frequency (%)
León	176821	39.6%
Valladolid	80460	18.0%
Palencia	61857	13.9%
Burgos	57906	13.0%
Salamanca	31204	7.0%
Soria	10482	2.4%
Zamora	8398	1.9%
Segovia	8245	1.8%
Avila	7389	1.7%
Madrid	3252	0.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
león	176821	39.6%
valladolid	80460	18.0%
palencia	61857	13.9%
burgos	57906	13.0%
salamanca	31204	7.0%
soria	10482	2.4%
zamora	8398	1.9%
segovia	8245	1.8%
avila	7389	1.7%
madrid	3252	0.7%

Most occurring characters

Value	Count	Frequency (%)
a	455614	16.0%
l	341830	12.0%
n	269882	9.5%
e	246923	8.7%
L	176821	6.2%
ó	176821	6.2%
i	171685	6.0%
d	167424	5.9%
o	165491	5.8%
c	93061	3.3%
Other values (13)	586430	20.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2405968	84.4%
Uppercase Letter	446014	15.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	455614	18.9%
l	341830	14.2%
n	269882	11.2%
e	246923	10.3%
ó	176821	7.3%
i	171685	7.1%
d	167424	7.0%
o	165491	6.9%
c	93061	3.9%
r	80038	3.3%
Other values (5)	237199	9.9%

Uppercase Letter

Value	Count	Frequency (%)
L	176821	39.6%
V	80460	18.0%
P	61857	13.9%
B	57906	13.0%
S	49931	11.2%
Z	8398	1.9%
A	7389	1.7%
M	3252	0.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2851982	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	455614	16.0%
l	341830	12.0%
n	269882	9.5%
e	246923	8.7%
L	176821	6.2%
ó	176821	6.2%
i	171685	6.0%
d	167424	5.9%
o	165491	5.8%
c	93061	3.3%
Other values (13)	586430	20.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2675161	93.8%
None	176821	6.2%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	455614	17.0%
l	341830	12.8%
n	269882	10.1%
e	246923	9.2%
L	176821	6.6%
i	171685	6.4%
d	167424	6.3%
o	165491	6.2%
c	93061	3.5%
V	80460	3.0%
Other values (12)	505970	18.9%

None

Value	Count	Frequency (%)
ó	176821	100.0%

Estación
Categorical

HIGH CARDINALITY

Distinct	91
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	438.5 KiB

Guardo	8644
Leon1	8630
La Robla	8577
Burgos4	8532
Miranda de Ebro2	8521
Other values (86)	403110

Length

Max length	32
Median length	25
Mean length	14.246275
Min length	3

Characters and Unicode

Total characters	6.354.038
Distinct characters	53
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Burgos1
2nd row	C.T.L.R. - Naredo
3rd row	Carracedelo
4th row	La Robla
5th row	Tudela Veguin-Tudela Veguin

Common Values

Value	Count	Frequency (%)
Guardo	8644	1.9%
Leon1	8630	1.9%
La Robla	8577	1.9%
Burgos4	8532	1.9%
Miranda de Ebro2	8521	1.9%
Medina del Campo	8503	1.9%
Miranda de Ebro1	8224	1.8%
Renault3	8154	1.8%
Renault2	8095	1.8%
Renault4	8082	1.8%
Other values (81)	362052	81.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	82839	9.1%
de	60808	6.7%
c.t.anllares	35105	3.9%
del	26156	2.9%
c.t.l.r	22403	2.5%
la	20978	2.3%
miranda	19207	2.1%
2	17772	2.0%
ii	17516	1.9%
c.t.g	14250	1.6%
Other values (112)	592242	65.1%

Most occurring characters

Value	Count	Frequency (%)
a	703230	11.1%
l	510181	8.0%
	463262	7.3%
o	457350	7.2%
e	422344	6.6%
r	328159	5.2%
n	298781	4.7%
i	298635	4.7%
.	296522	4.7%
C	226115	3.6%
Other values (43)	2349459	37.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4224150	66.5%
Uppercase Letter	1044761	16.4%
Space Separator	463262	7.3%
Other Punctuation	296522	4.7%
Decimal Number	191217	3.0%
Dash Punctuation	133417	2.1%
Other Letter	709	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	703230	16.6%
l	510181	12.1%
o	457350	10.8%
e	422344	10.0%
r	328159	7.8%
n	298781	7.1%
i	298635	7.1%
d	215187	5.1%
s	194480	4.6%
t	175994	4.2%
Other values (13)	619809	14.7%

Uppercase Letter

Value	Count	Frequency (%)
C	226115	21.6%
T	132798	12.7%
S	93728	9.0%
L	81887	7.8%
R	78419	7.5%
A	71195	6.8%
M	67805	6.5%
V	59473	5.7%
P	51174	4.9%
I	38139	3.7%
Other values (10)	144028	13.8%

Decimal Number

Value	Count	Frequency (%)
2	59848	31.3%
1	53473	28.0%
4	32307	16.9%
3	29491	15.4%
5	11197	5.9%
6	4901	2.6%

Space Separator

Value	Count	Frequency (%)
	463262	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	296522	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	133417	100.0%

Other Letter

Value	Count	Frequency (%)
º	709	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5269620	82.9%
Common	1084418	17.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	703230	13.3%
l	510181	9.7%
o	457350	8.7%
e	422344	8.0%
r	328159	6.2%
n	298781	5.7%
i	298635	5.7%
C	226115	4.3%
d	215187	4.1%
s	194480	3.7%
Other values (34)	1615158	30.7%

Common

Value	Count	Frequency (%)
	463262	42.7%
.	296522	27.3%
-	133417	12.3%
2	59848	5.5%
1	53473	4.9%
4	32307	3.0%
3	29491	2.7%
5	11197	1.0%
6	4901	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6331848	99.7%
None	22190	0.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	703230	11.1%
l	510181	8.1%
	463262	7.3%
o	457350	7.2%
e	422344	6.7%
r	328159	5.2%
n	298781	4.7%
i	298635	4.7%
.	296522	4.7%
C	226115	3.6%
Other values (39)	2327269	36.8%

None

Value	Count	Frequency (%)
ñ	15603	70.3%
í	3252	14.7%
á	2626	11.8%
º	709	3.2%

Latitud
Real number (ℝ)

Distinct	101
Distinct (%)	< 0.1%
Missing	226
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	42.151547

Minimum	38.938333
Maximum	43.603333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.4 MiB

Quantile statistics

Minimum	38.938333
5-th percentile	40.949722
Q1	41.645556
median	42.542778
Q3	42.688056
95-th percentile	42.849167
Maximum	43.603333
Range	4.665
Interquartile range (IQR)	1.0425

Descriptive statistics

Standard deviation	0.66550058
Coefficient of variation (CV)	0.015788284
Kurtosis	-0.59538138
Mean	42.151547
Median Absolute Deviation (MAD)	0.30638889
Skewness	-0.6832054
Sum	18790654
Variance	0.44289103
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.94972222	10177	2.3%
41.67111111	8654	1.9%
41.31638889	8503	1.9%
41.61277778	8154	1.8%
41.60416667	8095	1.8%
41.96138889	8082	1.8%
41.6	7922	1.8%
42.79527778	7913	1.8%
42.60388889	7900	1.8%
42.80277778	7847	1.8%
Other values (91)	362541	81.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
38.93833333	36	< 0.1%
40.38694444	3252	0.7%
40.56944444	729	0.2%
40.57055556	2885	0.6%
40.65861111	4253	1.0%
40.66472222	3136	0.7%
40.94972222	10177	2.3%
40.95555556	3245	0.7%
40.95583333	727	0.2%
40.96055556	729	0.2%

Value	Count	Frequency (%)
43.60333333	730	0.2%
43.04166667	708	0.2%
43.04111111	3038	0.7%
42.9525	3102	0.7%
42.95166667	716	0.2%
42.94416667	6667	1.5%
42.87777778	5547	1.2%
42.84916667	7211	1.6%
42.84638889	6225	1.4%
42.8425	2342	0.5%

Longitud
Real number (ℝ)

Distinct	100
Distinct (%)	< 0.1%
Missing	226
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	-5.1789653

Minimum	-6.7819444
Maximum	-2.4666667
Zeros	0
Zeros (%)	0.0%
Negative	445788
Negative (%)	99.9%
Memory size	3.4 MiB

Quantile statistics

Minimum	-6.7819444
5-th percentile	-6.6622222
Q1	-6.4838889
median	-4.9091667
Q3	-4.5383333
95-th percentile	-2.9405556
Maximum	-2.4666667
Range	4.3152778
Interquartile range (IQR)	1.9455556

Descriptive statistics

Standard deviation	1.1219204
Coefficient of variation (CV)	-0.21663022
Kurtosis	-0.62728166
Mean	-5.1789653
Median Absolute Deviation (MAD)	0.75277778
Skewness	0.34897154
Sum	-2308720.6
Variance	1.2587053
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-6.725555556	12407	2.8%
-6.520833333	11157	2.5%
-3.683888889	8654	1.9%
-4.909166667	8503	1.9%
-4.740833333	8154	1.8%
-4.728888889	8095	1.8%
-4.494444444	8082	1.8%
-4.7325	7922	1.8%
-4.840833333	7913	1.8%
-5.587222222	7900	1.8%
Other values (90)	357001	80.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6.781944444	6257	1.4%
-6.725555556	12407	2.8%
-6.662222222	4555	1.0%
-6.653611111	4565	1.0%
-6.643333333	6717	1.5%
-6.625	1812	0.4%
-6.603888889	5887	1.3%
-6.600277778	4609	1.0%
-6.589444444	6647	1.5%
-6.588888889	2501	0.6%

Value	Count	Frequency (%)
-2.466666667	5856	1.3%
-2.480555556	731	0.2%
-2.856944444	3895	0.9%
-2.9175	7742	1.7%
-2.918055556	482	0.1%
-2.940277778	731	0.2%
-2.940555556	7790	1.7%
-2.954444444	2462	0.6%
-3.475277778	3818	0.9%
-3.636111111	7806	1.8%

Posición
Text

Distinct	106
Distinct (%)	< 0.1%
Missing	226
Missing (%)	0.1%
Memory size	3.4 MiB

Length

Max length	28
Median length	28
Mean length	26.7056
Min length	12

Characters and Unicode

Total characters	11.905.036
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	42.3511111111,-3.67555555556
2nd row	42.8166666667,-5.53333333333
3rd row	42.5586111111,-6.72555555556
4th row	42.8016666667,-5.625
5th row	42.8016666667,-5.64888888889

Value	Count	Frequency (%)
41.6711111111,-3.68388888889	8654	1.9%
41.3163888889,-4.90916666667	8503	1.9%
41.6127777778,-4.74083333333	8154	1.8%
41.6041666667,-4.72888888889	8095	1.8%
41.9613888889,-4.49444444444	8082	1.8%
41.6,-4.7325	7922	1.8%
42.7952777778,-4.84083333333	7913	1.8%
42.6038888889,-5.58722222222	7900	1.8%
42.8027777778,-5.62361111111	7847	1.8%
42.3361111111,-3.63611111111	7806	1.8%
Other values (96)	364912	81.9%

Most occurring characters

Value	Count	Frequency (%)
4	1527192	12.8%
8	1324244	11.1%
6	1243180	10.4%
5	1178927	9.9%
3	1135738	9.5%
1	1116551	9.4%
7	994101	8.4%
2	950239	8.0%
.	891576	7.5%
,	445788	3.7%
Other values (3)	1097500	9.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	10121884	85.0%
Other Punctuation	1337364	11.2%
Dash Punctuation	445788	3.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	1527192	15.1%
8	1324244	13.1%
6	1243180	12.3%
5	1178927	11.6%
3	1135738	11.2%
1	1116551	11.0%
7	994101	9.8%
2	950239	9.4%
9	375419	3.7%
0	276293	2.7%

Other Punctuation

Value	Count	Frequency (%)
.	891576	66.7%
,	445788	33.3%

Dash Punctuation

Value	Count	Frequency (%)
-	445788	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	11905036	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
4	1527192	12.8%
8	1324244	11.1%
6	1243180	10.4%
5	1178927	9.9%
3	1135738	9.5%
1	1116551	9.4%
7	994101	8.4%
2	950239	8.0%
.	891576	7.5%
,	445788	3.7%
Other values (3)	1097500	9.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11905036	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	1527192	12.8%
8	1324244	11.1%
6	1243180	10.4%
5	1178927	9.9%
3	1135738	9.5%
1	1116551	9.4%
7	994101	8.4%
2	950239	8.0%
.	891576	7.5%
,	445788	3.7%
Other values (3)	1097500	9.2%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Fecha	CO (mg/m3)	NO (ug/m3)	NO2 (ug/m3)	O3 (ug/m3)	PM10 (ug/m3)	PM25 (ug/m3)	SO2 (ug/m3)	Provincia	Estación	Latitud	Longitud	Posición
0	2020-12-31	0.6	8.0	16.0	NaN	6.0	NaN	1.0	Burgos	Burgos1	42.351111	-3.675556	42.3511111111,-3.67555555556
1	2020-12-31	NaN	2.0	6.0	NaN	8.0	NaN	4.0	León	C.T.L.R. - Naredo	42.816667	-5.533333	42.8166666667,-5.53333333333
2	2020-12-31	NaN	8.0	2.0	65.0	4.0	NaN	2.0	León	Carracedelo	42.558611	-6.725556	42.5586111111,-6.72555555556
3	2020-12-31	NaN	1.0	4.0	58.0	21.0	NaN	17.0	León	La Robla	42.801667	-5.625000	42.8016666667,-5.625
4	2020-12-31	NaN	1.0	1.0	NaN	6.0	NaN	2.0	León	Tudela Veguin-Tudela Veguin	42.801667	-5.648889	42.8016666667,-5.64888888889
5	2020-12-31	NaN	2.0	2.0	62.0	6.0	NaN	6.0	León	Valderas	42.079722	-5.448889	42.0797222222,-5.44888888889
6	2020-12-31	NaN	5.0	9.0	56.0	5.0	NaN	5.0	Palencia	Guardo	42.791389	-4.846389	42.7913888889,-4.84638888889
7	2020-12-31	NaN	2.0	6.0	53.0	6.0	NaN	5.0	Palencia	Hontoria 1 - Poblado	41.932778	-4.470000	41.9327777778,-4.47
8	2020-12-31	NaN	2.0	6.0	59.0	5.0	NaN	NaN	Palencia	Renault4	41.961389	-4.494444	41.9613888889,-4.49444444444
9	2020-12-31	NaN	1.0	1.0	81.0	NaN	NaN	2.0	Salamanca	El Maillo	40.569444	-6.223889	40.5694444444,-6.22388888889

	Fecha	CO (mg/m3)	NO (ug/m3)	NO2 (ug/m3)	O3 (ug/m3)	PM10 (ug/m3)	PM25 (ug/m3)	SO2 (ug/m3)	Provincia	Estación	Latitud	Longitud	Posición
446004	1997-01-01	2.4	32.0	48.0	52.0	NaN	NaN	17.0	Palencia	Palencia2	42.003611	-4.524722	42.0036111111,-4.52472222222
446005	1997-01-01	NaN	10.0	15.0	57.0	51.0	NaN	23.0	Palencia	Velilla del Rio Carrion	42.828056	-4.843056	42.8280555556,-4.84305555556
446006	1997-01-01	1.5	23.0	37.0	54.0	NaN	NaN	14.0	Salamanca	Salamanca4	40.949722	-5.658333	40.9497222222,-5.65833333333
446007	1997-01-01	1.1	23.0	43.0	291.0	52.0	NaN	6.0	Burgos	Burgos1	42.350833	-3.675556	42.3508333333,-3.67555555556
446008	1997-01-01	1.2	43.0	54.0	29.0	124.0	NaN	32.0	León	Leon1	42.603889	-5.587222	42.6038888889,-5.58722222222
446009	1997-01-01	NaN	31.0	44.0	9.0	36.0	NaN	37.0	León	Leon2	42.588611	-5.571389	42.5886111111,-5.57138888889
446010	1997-01-01	NaN	9.0	18.0	32.0	35.0	NaN	40.0	Palencia	Guardo	42.795278	-4.840833	42.7952777778,-4.84083333333
446011	1997-01-01	1.5	13.0	31.0	32.0	45.0	NaN	8.0	Burgos	Aranda de Duero	41.671111	-3.683889	41.6711111111,-3.68388888889
446012	1997-01-01	2.0	17.0	54.0	86.0	32.0	NaN	13.0	Segovia	Segovia	40.949722	-4.115833	40.9497222222,-4.11583333333
446013	1997-01-01	4.8	122.0	86.0	NaN	NaN	72.0	110.0	Salamanca	Salamanca1	40.973611	-5.662778	40.9736111111,-5.66277777778

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Other Punctuation

Dash Punctuation

Other Letter

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Missing values

Sample